﻿update dbo.GoodsCodeType set ExtNumeric1 = 0 where ExtNumeric1 is null;
update dbo.GoodsCodeType set ExtNumeric2 = 0 where ExtNumeric2 is null;
update dbo.GoodsCodeType set ExtNumeric3 = 0 where ExtNumeric3 is null;
update dbo.GoodsCodeType set ExtNumeric4 = 0 where ExtNumeric4 is null;